package com.isdepci.project.carbon.mapper;

import com.isdepci.project.carbon.domain.BGreenCarbonSink;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 绿化碳汇Mapper接口
 *
 * @author isdepci
 * @date 2025-03-29
 */
public interface BGreenCarbonSinkMapper
{

    // 按照年份查询
    List<BGreenCarbonSink> selectByYear(@Param("projectId") Long projectId, @Param("startYear") String startYear, @Param("endYear") String endYear);

    // 按照月份查询
    List<BGreenCarbonSink> selectByMonth(@Param("projectId") Long projectId, @Param("startMonth") String startMonth, @Param("endMonth") String endMonth);


    /**
     * 查询绿化碳汇
     */
     BGreenCarbonSink selectBGreenCarbonSinkById(Long id);

    /**
     * 查询绿化碳汇列表
     */
     List<BGreenCarbonSink> selectBGreenCarbonSinkList(BGreenCarbonSink bGreenCarbonSink);

    /**
     * 新增绿化碳汇
     */
     int insertBGreenCarbonSink(BGreenCarbonSink bGreenCarbonSink);

    /**
     * 修改绿化碳汇
     */
     int updateBGreenCarbonSink(BGreenCarbonSink bGreenCarbonSink);

    /**
     * 删除绿化碳汇
     */
     int deleteBGreenCarbonSinkById(Long id);

    /**
     * 批量删除绿化碳汇
     */
     int deleteBGreenCarbonSinkByIds(Long[] ids);


    void insertList(@Param("list") List<BGreenCarbonSink> list);


    List<BGreenCarbonSink> selectBGreenCarbonSinkByProjectId(Long projectId);
}
